﻿/*
后期部署脚本模板							
--------------------------------------------------------------------------------------
 此文件包含将附加到生成脚本中的 SQL 语句。		
 使用 SQLCMD 语法将文件包含到后期部署脚本中。			
 示例:      :r .\myfile.sql								
 使用 SQLCMD 语法引用后期部署脚本中的变量。		
 示例:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
delete from JF_T_FieldTypeCategory
delete from JF_T_DataType

insert JF_T_FieldTypeCategory (Id, Name, SortIndex, [IsPrivate]) values ('7AF644B7-B0C7-41C7-A3D2-889ACD6A2875', '用户管理业务', 0, 1)
insert JF_T_FieldTypeCategory (Id, Name, SortIndex, [IsPrivate]) values ('C6A2FF17-EC5B-4995-B222-58239A4786D0', 'OA业务', 1, 1)
insert JF_T_FieldTypeCategory (Id, Name, SortIndex, [IsPrivate]) values ('A1D000D4-8468-41CB-96AB-901F697A8773', '请假业务', 2, 1)
insert JF_T_FieldTypeCategory (Id, Name, SortIndex, [IsPrivate]) values ('9202895B-4107-41AD-B886-01DB3DE3F61E', '其他业务', 3, 1)

insert JF_T_DataType ([Id], [Code], [Caption], [IsLimitLength], [IsMaxLengthOptional], [IsMinLengthOptional], [MinLength], [MaxLength],[IsPrivate])
     values ('EF9A2DEB-9009-4CB9-8F2B-85CFEB758E3A', 'string', '字符串', 1, 1, 1, 0, 1024, 1)
insert JF_T_DataType ([Id], [Code], [Caption], [IsLimitLength], [IsMaxLengthOptional], [IsMinLengthOptional], [MinLength], [MaxLength],[IsPrivate])
     values ('D9626B94-BC72-44FA-A193-7316BF8663D2', 'int', '整数', 0, null, null, null, null, 1)
insert JF_T_DataType ([Id], [Code], [Caption], [IsLimitLength], [IsMaxLengthOptional], [IsMinLengthOptional], [MinLength], [MaxLength],[IsPrivate])
     values ('BAEB852B-CD41-4AFD-B0B9-28B1336C159F', 'datetime', '日期', 0, null, null, null, null, 1)
insert JF_T_DataType ([Id], [Code], [Caption], [IsLimitLength], [IsMaxLengthOptional], [IsMinLengthOptional], [MinLength], [MaxLength],[IsPrivate])
     values ('A8DD1B7E-D5BE-4512-A0AE-6B7279A2F1E8', 'guid', 'GUID', 0, null, null, null, null, 1)